<?php
include('header.php');
include('Fonctions.php');

$etude = $bdd->prepare("SELECT numero_affaire FROM etude_municipalite");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtod">

<html xmlns = "http://www.w3.org/1999/xhtml" xml:lang = "fr" >
    <head>		
        <meta http-equiv = "Content-Type" content = "text/html; charset = UTF-8" />
        <title> Liste des &eacutetudes </title>
    </head>
    <body>

        <div id="corps">

            <div id="header">
                <div id="contenu">

                    <?php
                    $etude->execute();
                    if ($etude->rowCount() == 0) {
                        echo "Il n'y a aucune &eacutetude en cours <br />";
                    }
                    while ($affiche_etude = $etude->fetch()) {
                        echo "<a href = 'Suivi_etude.php?Num=" . $affiche_etude['numero_affaire'] . "'> " . $affiche_etude['numero_affaire'] . " </a> <br />";
                    }
                    ?>

                    <a href = "Accueil_municipalite.php"><input type = "button" id = "retour" name = "retour" value = "Retour"/></a>
                </div>
            </div>
        </div>

<?php
include('footer.php');
?>
    </body>
</html>
